USE [MyTest]
GO

/****** Object:  Table [dbo].[TBL_SMS_CONTENT_20251221]    Script Date: 2025/10/23 15:25:32 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TBL_SMS_CONTENT_20251221](
	[id] [bigint] NOT NULL,
	[content] [nvarchar](2000) NULL,
	[sendTime] [datetime] NULL,
	[addTime] [datetime] NULL,
	[mobileCount] [int] NULL,
	[msgCount] [smallint] NULL,
	[mgateway] [int] NULL,
	[tgateway] [int] NULL,
	[ugateway] [int] NULL,
	[status] [smallint] NULL,
	[ucuid] [varchar](32) NULL,
	[source] [tinyint] NULL,
	[eprId] [int] NOT NULL,
	[priority] [tinyint] NULL,
	[md5Content] [varchar](16) NULL,
	[statusCode] [varchar](12) NULL,
	[platform] [tinyint] NOT NULL,
	[tempId] [int] NULL,
	[contentType] [int] NULL,
	[taskId] [int] NULL,
	[custTempId] [int] NULL,
	[timing] [tinyint] NULL,
	[hfType] [tinyint] NOT NULL,
	[onlyId] [bigint] NOT NULL,
	[updateTime] [datetime2](3) NOT NULL,
 CONSTRAINT [PK_TBL_SMS_CONTENT_20251221] PRIMARY KEY NONCLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TBL_SMS_CONTENT_20251221] ADD  CONSTRAINT [DF__TBL_SMS_C__EPRID_20251221]  DEFAULT ((0)) FOR [eprId]
GO

ALTER TABLE [dbo].[TBL_SMS_CONTENT_20251221] ADD  CONSTRAINT [DF_TBL_SMS_CONTENT_20251221_PRIORITY]  DEFAULT ((0)) FOR [priority]
GO

ALTER TABLE [dbo].[TBL_SMS_CONTENT_20251221] ADD  CONSTRAINT [DF__TBL_SMS_C__platf_20251221]  DEFAULT ((0)) FOR [platform]
GO

ALTER TABLE [dbo].[TBL_SMS_CONTENT_20251221] ADD  CONSTRAINT [DF_TBL_SMS_CONTENT_contentType_20251221]  DEFAULT ((-2)) FOR [contentType]
GO

ALTER TABLE [dbo].[TBL_SMS_CONTENT_20251221] ADD  CONSTRAINT [DF__TBL_SMS_C__taskI_20251221]  DEFAULT ((0)) FOR [taskId]
GO

ALTER TABLE [dbo].[TBL_SMS_CONTENT_20251221] ADD  CONSTRAINT [DF__TBL_SMS_C__custT_20251221]  DEFAULT ((0)) FOR [custTempId]
GO

ALTER TABLE [dbo].[TBL_SMS_CONTENT_20251221] ADD  CONSTRAINT [DF__TBL_SMS_C__timin_20251221]  DEFAULT ((0)) FOR [timing]
GO

ALTER TABLE [dbo].[TBL_SMS_CONTENT_20251221] ADD  CONSTRAINT [DF__TBL_SMS_C__hfTyp_20251221]  DEFAULT ((0)) FOR [hfType]
GO

ALTER TABLE [dbo].[TBL_SMS_CONTENT_20251221] ADD  CONSTRAINT [DF__TBL_SMS_C__onlyI_20251221]  DEFAULT ((0)) FOR [onlyId]
GO

ALTER TABLE [dbo].[TBL_SMS_CONTENT_20251221] ADD  CONSTRAINT [DF_TBL_SMSCONTENT_20251221_updateTime]  DEFAULT (getdate()) FOR [updateTime]
GO


